USE AdventureWorks2008

--Create a view
CREATE VIEW vwEmployeeLogins AS
	SELECT NationalIDNumber,
	            LoginID
	FROM HumanResources.Employee 
GO

--Query a view

SELECT * FROM vwEmployeeLogins

